[dbo].[GetUserKeyByUserId]

SQLServer > iMIS1521GA > Scalar-valued Functions > dbo.GetUserKeyByUserId

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserId	nvarchar(50)	100

SQL Script

CREATE  FUNCTION [dbo].[GetUserKeyByUserId]
  (@UserId nvarchar(50))
RETURNS uniqueidentifier
AS
BEGIN
    RETURN (SELECT TOP 1 UserKey FROM UserMain WHERE UserId = @UserId)
END

GO

Uses

[dbo].[UserMain]
dbo